PRINT '-------------------------------------------'
PRINT 'Starting execution of UM_LoginProviders.SQL'
PRINT '-------------------------------------------'
GO

SET QUOTED_IDENTIFIER OFF
SET ANSI_NULLS ON         -- We don't want (NULL = NULL) == TRUE
GO
SET ANSI_PADDING ON
GO
SET ANSI_NULL_DFLT_ON ON
GO

IF (NOT EXISTS (SELECT name
                FROM sysobjects
                WHERE (name = N'UM_LoginProviders')
                  AND (type = 'U')))
BEGIN
	  PRINT 'Creating the UM_LoginProviders table...'
	  CREATE TABLE [dbo].UM_LoginProviders(
		[LoginProviderId] [smallint] NOT NULL,
		[LoginProviderName] [varchar](50) NOT NULL,
		[LoginProviderDesc] [varchar](256) NULL,
		[IsActive] [bit] NULL,
	 CONSTRAINT [PK_UM_LoginProviders] PRIMARY KEY CLUSTERED 
	(
		[LoginProviderId] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]
END
GO



PRINT '--------------------------------------------'
PRINT 'Inserting Data UM_LoginProviders'
PRINT '--------------------------------------------'

INSERT INTO UM_LoginProviders ([LoginProviderId] ,[LoginProviderName],[LoginProviderDesc],[IsActive])     
	VALUES (1, 'Leisure', 'Leisure', '1')
INSERT INTO UM_LoginProviders ([LoginProviderId] ,[LoginProviderName],[LoginProviderDesc],[IsActive])     
	VALUES (2, 'Others', 'Others', '1')	
INSERT INTO UM_LoginProviders ([LoginProviderId] ,[LoginProviderName],[LoginProviderDesc],[IsActive])     
	VALUES (3, 'Twitter', 'Twitter', '1')	
INSERT INTO UM_LoginProviders ([LoginProviderId] ,[LoginProviderName],[LoginProviderDesc],[IsActive])     
	VALUES (4, 'Google', 'Google', '1')	
INSERT INTO UM_LoginProviders ([LoginProviderId] ,[LoginProviderName],[LoginProviderDesc],[IsActive])     
	VALUES (5, 'Yahoo', 'Yahoo', '1')	
INSERT INTO UM_LoginProviders ([LoginProviderId] ,[LoginProviderName],[LoginProviderDesc],[IsActive])     
	VALUES (6, 'WindowsLive', 'WindowsLive', '1')	
INSERT INTO UM_LoginProviders ([LoginProviderId] ,[LoginProviderName],[LoginProviderDesc],[IsActive])     
	VALUES (7, 'LinkedIN', 'LinkedIN', '1')		
INSERT INTO UM_LoginProviders ([LoginProviderId] ,[LoginProviderName],[LoginProviderDesc],[IsActive])     
	VALUES (8, 'WordPress', 'WordPress', '1')			
INSERT INTO UM_LoginProviders ([LoginProviderId] ,[LoginProviderName],[LoginProviderDesc],[IsActive])     
	VALUES (9, 'MySpace', 'MySpace', '1')	
INSERT INTO UM_LoginProviders ([LoginProviderId] ,[LoginProviderName],[LoginProviderDesc],[IsActive])     
	VALUES (10, 'OpenId', 'OpenId', '1')	
INSERT INTO UM_LoginProviders ([LoginProviderId] ,[LoginProviderName],[LoginProviderDesc],[IsActive])     
	VALUES (11, 'Facebook', 'Facebook', '1')	
INSERT INTO UM_LoginProviders ([LoginProviderId] ,[LoginProviderName],[LoginProviderDesc],[IsActive])     
	VALUES (12, 'AOL', 'AOL', '1')		
	
GO

PRINT '--------------------------------------------'
PRINT 'Completed execution of UM_LoginProviders.SQL'
PRINT '--------------------------------------------'

